FaApproveDisbCriteria

Logical Entity Name | FaApproveDisbCriteria
Default Table Name | FaApproveDisbCriteria
Physical Only | NO
Owner | dbo
Definition |
Note |

FaApproveDisbCriteria Columns

ColumnName | Domain | Datatype | NULL | Definition
FaApproveDisbCriteriaID |  | int | NO |
Code |  | char(10) | NO |
Descrip |  | varchar(40) | NO |
MinPctAttFlag |  | bit | NO |
MinPctAtt |  | numeric(8, 2) | NO |
MinHoursAttFlag |  | bit | NO |
MinHoursAtt |  | numeric(9, 2) | NO |
MinNumAvgFlag |  | bit | NO |
MinNumAvg |  | numeric(11, 6) | NO |
MinCumulativeGPAFlag |  | bit | NO |
MinCumulativeGPA |  | numeric(18, 6) | NO |
MinHoursCreditsSchedFlag |  | bit | NO |
MinHoursSched |  | numeric(18, 2) | NO |
MinCreditsSched |  | numeric(18, 2) | NO |
MinHoursCreditsCompFlag |  | bit | NO |
MinHoursComp |  | numeric(18, 2) | NO |
MinCreditsComp |  | numeric(18, 2) | NO |
FACrAttemptEarnedFlag |  | bit | NO |
FACrEarnedAttemp |  | char(1) | NO |
MaxDaysAfterStudLDAFlag |  | bit | NO |
MaxDaysAfterStudLDA |  | int | NO |
MissingDocsFlag |  | bit | NO |
StudSchoolStatusFlag |  | bit | NO |
ReqStudSAPFlag |  | bit | NO |
ReqStudSAP |  | char(8) | NO |
ISIROnFileFlag |  | bit | NO |
AcceptedOriginationFlag |  | bit | NO |
VerifyStatusFlag |  | bit | NO |
VerifyStatus |  | varchar(25) | NO |
MaxDiffDisbAmtFlag |  | bit | NO |
MaxDiffDisbAmt |  | money | NO |
MaxDaysTermDisbDateFlag |  | bit | NO |
MaxDaysTermDisbDate |  | int | NO |
FirstTimeTermStudFlag |  | bit | NO |
MaxDaysFromLoanEndDateFlag |  | bit | NO |
MaxDaysFromLoanEndDate |  | int | NO |
Active |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
Ts |  | timestamp | NO |
MatchEnrollmentPackagedStatusFlag |  | bit | NO |
EvaluateTerm |  | bit | NO |
CheckAttendanceAll |  | bit | NO |
CheckCompletionDate |  | bit | NO |
CertifiedBeforeLDA |  | bit | NO |
StateofResidencyFlag |  | bit | NO |
StateofResidencyState |  | char(2) | YES |
StateResidentSinceFlag |  | bit | NO |
ResidentYears |  | smallint | YES |
BachelorsDegree |  | char(1) | NO |
GraduateLevelProgram |  | char(1) | NO |
EntranceInterview |  | bit | NO |
MinAdAttStatId |  | int | YES |
MinPaymentPeriodAttFlag |  | bit | NO |
MinPaymentPeriodAtt |  | numeric(9, 2) | NO |
EnrollmentIntensityFlag |  | bit | NO |
FaCreditsNonT4Awards |  | bit | NO |

FaApproveDisbCriteria Primary and Unique Keys

Key Name | Key Type | Keys
FaApproveDisbCriteria_Code_U_N_IDX | Index | Code
FaApproveDisbCriteria_FaApproveDisbCriteriaID_U_C_IDX | PrimaryKey | FaApproveDisbCriteriaID

FaApproveDisbCriteria Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AdAttStat | Non-Identifying | Zero or One to Zero or More | FK_FaApproveDisbCriteria_MinAdAttStatId_AdAttStat_AdAttStatId |  |  | MinAdAttStatId | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_FaApproveDisbCriteria_UserID_SyStaff_SyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
FaApprovDisbSchoolStatus | Identifying | One To Zero or More | FK_FaApprovDisbSchoolStatus_FaApproveDisbCriteriaID_FaApproveDisbCriteria_FaApproveDisbCriteriaID |  |  |  | NO | YES
FaApproveDisbCriteriaSubsequent | Non-Identifying | One To Zero or More | FK_FaApproveDisbCriteriaSubsequent_FaApproveDisbCriteriaID_FaApproveDisbCriteria_aFaApproveDisbCriteriaID |  |  |  | NO | YES
FaApproveDisbDocTypes | Identifying | One To Zero or More | FK_FaApproveDisbDocTypes_FaApproveDisbCriteriaID |  |  |  | NO | YES
FaDisbCriteriaCampusFundSource | Non-Identifying | One To Zero or More | FK_FaDisbCriteriaCampusFundSource_FaApproveDisbCriteriaID_FaApproveDisbCriteria_FaApproveDisbCriteriaID |  |  |  | NO | YES

FaApproveDisbCriteria Check Constraints

Check Constraint Name | CheckConstraint
Chk_FaApproveDisbCriteria_MinCumulativeGPAFlag_MinCumulativeGPA | ([MinCumulativeGPAFlag] = 1 and [MinCumulativeGPA] > 0 or [MinCumulativeGPAFlag] = 0 and [MinCumulativeGPA] = 0)
Chk_FaApproveDisbCriteria_MinNumAvgFlag_MinNumAvg | ([MinNumAvgFlag] = 1 and [MinNumAvg] > 0 or [MinNumAvgFlag] = 0 and [MinNumAvg] = 0)
Chk_FaApproveDisbCriteria_MinHoursAttFlag_MinHoursAtt | ([MinHoursAttFlag] = 1 and [MinHoursAtt] > 0 or [MinHoursAttFlag] = 0 and [MinHoursAtt] = 0)
Chk_FaApproveDisbCriteria_MinPctAttFlag_MinPctAtt | ([MinPctAttFlag] = 1 and [MinPctAtt] > 0 or [MinPctAttFlag] = 0 and [MinPctAtt] = 0)
Chk_MinHoursCreditsSchedFlag_MinHoursSched_MinCreditsSched | ([MinHoursCreditsSchedFlag] = 1 and ([MinHoursSched] > 0 or [MinCreditsSched] > 0) or [MinHoursCreditsSchedFlag] = 0 and ([MinHoursSched] = 0 and [MinCreditsSched] = 0))
Chk_MinHoursCreditsCompFlag_MinHoursSched_MinCreditsComp | ([MinHoursCreditsCompFlag] = 1 and ([MinHoursComp] > 0 or [MinCreditsComp] > 0) or [MinHoursCreditsCompFlag] = 0 and ([MinHoursComp] = 0 and [MinCreditsComp] = 0))
Chk_FaApproveDisbCriteria_MaxDaysFromLoanEndDateFlag_MaxDaysFromLoanEndDate | ([MaxDaysFromLoanEndDateFlag] = 1 and [MaxDaysFromLoanEndDate] >= 0 or [MaxDaysFromLoanEndDateFlag] = 0 and [MaxDaysFromLoanEndDate] = 0)
Chk_FaApproveDisbCriteria_MaxDiffDisbAmtFlag_MaxDiffDisbAmt | ([MaxDiffDisbAmtFlag] = 1 and [MaxDiffDisbAmt] >= 0 or [MaxDiffDisbAmtFlag] = 0 and [MaxDiffDisbAmt] = 0)
Chk_FaApproveDisbCriteria_MaxDaysAfterStudLDAFlag_MaxDaysAfterStudLDA | ([MaxDaysAfterStudLDAFlag] = 1 and [MaxDaysAfterStudLDA] >= 0 or [MaxDaysAfterStudLDAFlag] = 0 and [MaxDaysAfterStudLDAFlag] = 0)

FaApproveDisbCriteria Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaApproveDisbCriteria Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.DisbursementApprovalRule | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaApproveDisbCriteria | NO |  |  |

FaApproveDisbCriteria Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaApproveDisbCriteria Data Movement Rules

Name | Type | Rule Text/Value